Field Explorer

Overview

The Field Explorer is used to insert, modify or delete fields on the Design and Preview tabs of Seagate Crystal Reports. You'll see the Field Explorer after you have:

• selected a data source for a new report
• clicked the Insert Fields button on the Standard toolbar
• selected Database Field, Formula Field, Parameter Field, Special Field, Running total field, or SQL Expression Field from the Insert menu.

The Field Explorer displays a tree view of database fields and special fields that you can add to your report. It also shows formula fields, SQL expression fields, parameter fields, group name fields, and running total fields that you have defined for use in your report.

Fields that have already been added to the report, or fields that have been used by other fields (such as formula fields, groups, running total fields, summaries, and so on) have a check mark in front of them.

Toolbar and shortcut menu

The toolbar provides buttons with tool tips and hot-key combinations. You can right-click any item in the tree view to bring up a shortcut menu.

The toolbar and the shortcut menu offer these functions:

• Insert to Report
  Use this option to add a field to the report. You can insert more than one field at a time by selecting multiple fields, right-clicking, and choosing Insert to Report.

  Alternatively, to insert a field, you can drag and drop it in the Design or Preview tabs.

• Browse Data
  Use this option to browse data for a database field or formula field.

  When you right-click a database field, the shortcut menu has Insert to Report and Browse Data enabled.

• New
  Use this option to create a formula field, SQL expression field, parameter field or running total field.
• Edit
  Use this option to modify an existing formula field, SQL expression field, parameter field or running total field.
• Rename
  Use this option to modify the name of an existing formula field, SQL expression field, parameter field or running total field.
• Delete
  Use this option to remove a formula field, SQL expression field, parameter field or running total field. You can also select multiple fields, right-click, and choose Delete to remove them all at once.
• Move Parameter Up (or Down)
  Use this option to change the order of parameter fields.

  When you right-click a parameter field, all the functions except Browse Data are enabled.

Related topics

Database Field command

Formula Field command

Parameter Field command

Creating a parameter field